package electricity.mapper;

import com.github.pagehelper.Page;
import electricity.domain.DeviceInfo;
import electricity.dto.DeviceInfoDto;
import electricity.dto.DeviceQueryDTO;
import electricity.vo.DeviceParamsVo;
import electricity.vo.DeviceVO;
import electricity.vo.HealthyVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author haoyi
* @description 针对表【device_info】的数据库操作Mapper
* @createDate 2025-07-09 16:01:31
* @Entity generator.domain.DeviceInfo
*/
public interface DeviceInfoMapper {

    int deleteByPrimaryKey(Long id);

    int insert(DeviceInfo record);

    int insertSelective(DeviceInfo record);

    @Select("select * from device_info where id = #{id}")
    DeviceInfo selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(DeviceInfo record);

    int updateByPrimaryKey(DeviceInfoDto deviceInfoDto);


     Page<DeviceVO> pageQuery(DeviceQueryDTO deviceQueryDTO);

    List<DeviceInfo> selectList(DeviceQueryDTO deviceQueryDTO);


    Page<DeviceParamsVo> paramspageQuery(DeviceQueryDTO deviceQueryDTO);


    HealthyVo gethealthStats();

    List<DeviceInfo> selectByPage(int start, int size);

    int selectTotalCount();
}
